27. Video: WHERE with Non-Numeric Data
WHERE with Non-Numeric Data
The WHERE statement can also be used with non-numeric data. We can use the =
and !=
operators here. You need to be sure to use single quotes (just be careful if you have quotes in the original text) with the text data, not double quotes.
Commonly when we are using WHERE with non-numeric data fields, we use the LIKE, NOT, or IN operators. We will see those before the end of this lesson!